﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='operation_select' and s.name='Budget')
DROP PROCEDURE [Budget].operation_select
GO
CREATE PROCEDURE [Budget].operation_select 
@PK uniqueidentifier
AS
BEGIN
SELECT 	
	[Operations].[id_schedule] AS [PK],
	[Operations].[name] AS [Name]
FROM 
	[Operations] 
WHERE
	[Operations].[id_schedule] = @PK 
END